﻿CREATE TABLE [dbo].[View] (
    [ViewID]      UNIQUEIDENTIFIER NOT NULL,
    [ListID]      UNIQUEIDENTIFIER NOT NULL,
    [BaseViewID]  VARCHAR (50)     NULL,
    [Scope]       VARCHAR (50)     NULL,
    [StyleID]     VARCHAR (50)     NULL,
    [Title]       VARCHAR (50)     NULL,
    [Type]        VARCHAR (50)     NULL,
    [RowLimit]    INT              NULL,
    [FieldsCount] INT              NULL,
    CONSTRAINT [PK_Views_2] PRIMARY KEY CLUSTERED ([ViewID] ASC),
    CONSTRAINT [FK_View_List] FOREIGN KEY ([ListID]) REFERENCES [dbo].[List] ([ListID])
);

